﻿CREATE TABLE [dbo].[BookingServiceCustomerClassDetail] (
    [BookingId]       INT NOT NULL,
    [CustomerClassId] INT NOT NULL,
    [Amount]          INT NOT NULL,
    CONSTRAINT [PK_CTGiuChoLoaiKhachHang] PRIMARY KEY CLUSTERED ([BookingId] ASC, [CustomerClassId] ASC),
    CONSTRAINT [FK_BookingServiceCustomerClassDetail_BookingService] FOREIGN KEY ([BookingId]) REFERENCES [dbo].[BookingService] ([Id]),
    CONSTRAINT [FK_BookingServiceCustomerClassDetail_CustomerClass] FOREIGN KEY ([CustomerClassId]) REFERENCES [dbo].[CustomerClass] ([CustomerClassId])
);

